SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[_GRNDetails_AutoQuantity] @DrugId NVARCHAR(20)
AS 
    BEGIN
        SELECT  dbo.GRNDetails.*
        FROM    dbo.GRNDetails
        WHERE   IsComplete = 0
                AND DrugId = @DrugId
                AND LEFT(GRNId, 1) = 'A'
    END
        
GO
